/**
 * 
 */
package com.firebird.oms.dao.jdbc;

import java.util.List;
import java.util.Map;

import com.firebird.base.orm.jdbc.BaseJdbcDao;

/**
 * @author qiuxj 创建于 2009-11-17
 *
 */
public class OmsJdbcDao extends BaseJdbcDao {

	public void InsertWorker(Map<String, Object> map) {
		String sql = "insert into tism_staff(upper_staff_id,staff_name,sex,place_id,age,birthday,card_no,company_id,depart_id,rela_phone,rela_mobile,fax_phone,other_rela_phone,rela_addr,email,state) values(upper_staff_id,:staff_name,:sex,:place_id,:age,:birthday,:card_no,:company_id,:depart_id,:rela_phone,:rela_mobile,:fax_phone,:other_rela_phone,:rela_addr,:email,:state)";
		super.getSimpleJdbcTemplate().update(sql, map);
	}
	
	public List<Map<String, Object>> getWorker(){
		String sql = "select * from tism_staff";
		return super.getSimpleJdbcTemplate().queryForList(sql);
	}
	
}
